FaLoan_Proxy

EntityType | Independent
Logical Entity Name | FaLoan_Proxy
Default Table Name | FaLoan_Proxy
Logical Only | NO
Owner | dbo
Definition |
Note |

FaLoan_Proxy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaLoan_ProxyID |  | INTEGER | NO |
RecordID |  | INTEGER | YES |
Oldborrowerssn |  | CHAR(16) | YES |
Newborrowerssn |  | CHAR(16) | YES |
Oldborrowerlastname |  | CHAR(16) | YES |
Newborrowerlastname |  | CHAR(16) | YES |
Oldborrowerfirstname |  | CHAR(9) | YES |
Newborrowerfirstname |  | CHAR(9) | YES |
OldBorrowerAddress |  | VARCHAR(2000) | YES |
NewBorrowerAddress |  | VARCHAR(2000) | YES |
Oldborrowermi |  | CHAR(1) | YES |
Newborrowermi |  | CHAR(1) | YES |
Oldborrowercity |  | CHAR(16) | YES |
Newborrowercity |  | CHAR(16) | YES |
Oldborrowerstate |  | CHAR(2) | YES |
Newborrowerstate |  | CHAR(2) | YES |
Oldborrowerzip |  | CHAR(14) | YES |
Newborrowerzip |  | CHAR(14) | YES |
Oldborrowerphone |  | CHAR(16) | YES |
Newborrowerphone |  | CHAR(16) | YES |
Oldborrowerdriverlicensenumber |  | CHAR(20) | YES |
Newborrowerdriverlicensenumber |  | CHAR(20) | YES |
Oldborrowerdriverlicensestate |  | CHAR(2) | YES |
Newborrowerdriverlicensestate |  | CHAR(2) | YES |
Oldborrowerdob |  | DATETIME | YES |
Newborrowerdob |  | DATETIME | YES |
Oldborrowercitizenstatus |  | CHAR(1) | YES |
Newborrowercitizenstatus |  | CHAR(1) | YES |
Oldborrowerdefaultonloans |  | CHAR(1) | YES |
Newborrowerdefaultonloans |  | CHAR(1) | YES |
Olddatepnsigned |  | DATETIME | YES |
Newdatepnsigned |  | DATETIME | YES |
Oldstudentdefaultonloans |  | CHAR(1) | YES |
Newstudentdefaultonloans |  | CHAR(1) | YES |
OldAltBorrowerStudentLoanDebt |  | MONEY(19, 4) | YES |
NewAltBorrowerStudentLoanDebt |  | MONEY(19, 4) | YES |
OldborrowerInterestIndicator |  | CHAR(1) | YES |
NewborrowerInterestIndicator |  | CHAR(1) | YES |
OldborrowerLegalResState |  | CHAR(2) | YES |
NewborrowerLegalResState |  | CHAR(2) | YES |
OldborrowerLegalResStateDate |  | DATETIME | YES |
NewborrowerLegalResStateDate |  | DATETIME | YES |
OldborrowerOutstandingLoans |  | CHAR(1) | YES |
NewborrowerOutstandingLoans |  | CHAR(1) | YES |
OldborrowerReferenceCode |  | CHAR(1) | YES |
NewborrowerReferenceCode |  | CHAR(1) | YES |
OldDeferRequestCode |  | CHAR(1) | YES |
NewDeferRequestCode |  | CHAR(1) | YES |
OldEFTAuthorization |  | CHAR(1) | YES |
NewEFTAuthorization |  | CHAR(1) | YES |
OldProcessingCode |  | CHAR(2) | YES |
NewProcessingCode |  | CHAR(2) | YES |
OldPromNoteDeliveryCode |  | CHAR(1) | YES |
NewPromNoteDeliveryCode |  | CHAR(1) | YES |
OldSerialLoanCode |  | CHAR(1) | YES |
NewSerialLoanCode |  | CHAR(1) | YES |
OldStudentSignatureCode |  | CHAR(1) | YES |
NewStudentSignatureCode |  | CHAR(1) | YES |
UserId |  | INTEGER | NO |
OldCLApplicationStatus |  | CHAR(1) | YES |
NewCLApplicationStatus |  | CHAR(1) | YES |
DateAdded |  | DATETIME | NO |
OldPnSignedbyBorrower |  | CHAR(1) | YES |
NewPnSignedbyBorrower |  | CHAR(1) | YES |
OldDateSignedPnReceived |  | DATETIME | YES |
NewDateSignedPnReceived |  | DATETIME | YES |
OldMPNExpirationDate |  | DATETIME | YES |
NewMPNExpirationDate |  | DATETIME | YES |
OldPnDirectLoanID |  | CHAR(21) | YES |
NewPnDirectLoanID |  | CHAR(21) | YES |
OldDatePnPrinted |  | DATETIME | YES |
NewDatePnPrinted |  | DATETIME | YES |
OldDateDisclosurePrinted |  | DATETIME | YES |
NewDateDisclosurePrinted |  | DATETIME | YES |
OldBorrowerAlienId |  | CHAR(9) | YES |
NewBorrowerAlienId |  | CHAR(9) | YES |
OldBorrowerLocalZip |  | CHAR(10) | YES |
NewBorrowerLocalZip |  | CHAR(10) | YES |
OldUnSubEligibilityFlag |  | CHAR(1) | YES |
NewUnSubEligibilityFlag |  | CHAR(1) | YES |
OldUnSubEligibilityUpToHeal |  | CHAR(1) | YES |
NewUnSubEligibilityUpToHeal |  | CHAR(1) | YES |
OldBorrowerLocalAddress |  | VARCHAR(2000) | YES |
NewBorrowerLocalAddress |  | VARCHAR(2000) | YES |
OldBorrowerLocalCity |  | CHAR(16) | YES |
NewBorrowerLocalCity |  | CHAR(16) | YES |
OldBorrowerLocalState |  | CHAR(2) | YES |
NewBorrowerLocalState |  | CHAR(2) | YES |
OldLoanAmountApproved |  | MONEY(19, 4) | YES |
NewLoanAmountApproved |  | MONEY(19, 4) | YES |
OldOriginationFeePct |  | MONEY(19, 4) | YES |
NewOriginationFeePct |  | MONEY(19, 4) | YES |
OldPrintDisclosureAtLOC |  | BIT | YES |
NewPrintDisclosureAtLOC |  | BIT | YES |
OldStudentCitizenStatus |  | CHAR(1) | YES |
NewStudentCitizenStatus |  | CHAR(1) | YES |
OldStudentYearInCollege |  | CHAR(2) | YES |
NewStudentYearInCollege |  | CHAR(2) | YES |
Oldpnprintindicator |  | CHAR(1) | YES |
Newpnprintindicator |  | CHAR(1) | YES |

FaLoan_Proxy Keys

Key Name | Key Type | Keys
FaLoan_Proxy_UserID_N_N_IDX | Inversion Entry | UserId
PK_FaLoan_Proxy_FaLoan_ProxyID | PrimaryKey | FaLoan_ProxyID

FaLoan_Proxy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Staff | Non-Identifying | One To Zero or More |  |  |  | UserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaLoan_Proxy Check Constraints

Check Constraint Name | CheckConstraint

FaLoan_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaLoan_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaLoan_Proxy | NO |  |  |

FaLoan_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaLoan_Proxy Data Movement Rules

Name | Type | Rule Text/Value